Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_DIM_LEVEL_ATTR_MAPS

`ALL_OLAP2_DIM_LEVEL_ATTR_MAPS` shows the mapping of each level attribute to a column.

The mapping of level attributes to levels is dependent on hierarchy. The same level may have different attributes when it is used in different hierarchies.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension.
`DIMENSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension.
`HIERARCHY_NAME` | `VARCHAR2(30)` |  | Name of the hierarchy containing this level.
`ATTRIBUTE_NAME` | `VARCHAR2(30)` |  | Name of a dimension attribute grouping containing this level attribute.
`LVL_ATTRIBUTE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the level attribute, or name of the column if the level attribute name is not specified.
`LEVEL_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the level.
`TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension table containing the level and level attribute.
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension table containing the level and level attribute columns.
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the column containing the level attribute.
`DTYPE` | `VARCHAR2(10)` | `NOT NULL` | Data type of the column containing the level attribute.